inherited FrmCaixasLancamentos: TFrmCaixasLancamentos
  Left = 295
  Top = 158
  Caption = 'Fluxo de Caixa - Lan'#231'amentos de Caixas'
  ClientHeight = 491
  ClientWidth = 622
  OldCreateOrder = True
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  inherited Panel1: TPanel
    Top = 454
    Width = 622
    inherited Bitgrava: TBitBtn
      Left = 80
      Width = 72
    end
    inherited Bitexclui: TBitBtn
      Caption = '&Estornar'
    end
  end
  inherited Panel2: TPanel
    Width = 622
    Height = 454
    inherited Panel3: TPanel
      Width = 620
      Caption = 'Fluxo de Caixa - Lan'#231'amentos'
      inherited GroupBox1: TGroupBox
        Left = 541
      end
    end
    inherited Panel4: TPanel
      Width = 620
      Height = 412
      inherited SbHints: TStatusBar
        Top = 389
        Width = 612
      end
      object GB_DadosEstorno: TGroupBox
        Left = 4
        Top = 298
        Width = 612
        Height = 91
        Align = alBottom
        Caption = 'Estorno'
        TabOrder = 1
        object Label12: TLabel
          Left = 8
          Top = 18
          Width = 51
          Height = 13
          Caption = 'Data/Hora'
          FocusControl = edt_dataestorno
        end
        object Label13: TLabel
          Left = 107
          Top = 18
          Width = 36
          Height = 13
          Caption = 'Usu'#225'rio'
          FocusControl = edt_usuarioestorno
        end
        object Label14: TLabel
          Left = 264
          Top = 18
          Width = 32
          Height = 13
          Caption = 'Motivo'
          FocusControl = edt_motivoestorno
        end
        object edt_dataestorno: TDBEdit
          Left = 8
          Top = 34
          Width = 95
          Height = 21
          TabStop = False
          AutoSize = False
          Color = clBtnFace
          Ctl3D = False
          DataField = 'CXE_DATA'
          DataSource = DtSrcEstornos
          Enabled = False
          ParentCtl3D = False
          ReadOnly = True
          TabOrder = 0
        end
        object edt_usuarioestorno: TDBEdit
          Left = 107
          Top = 34
          Width = 41
          Height = 21
          TabStop = False
          AutoSize = False
          Color = clBtnFace
          Ctl3D = False
          DataField = 'CXE_USUARIO'
          DataSource = DtSrcEstornos
          Enabled = False
          ParentCtl3D = False
          ReadOnly = True
          TabOrder = 1
        end
        object edt_motivoestorno: TDBEdit
          Left = 264
          Top = 34
          Width = 334
          Height = 21
          Hint = 'Motivo do estorno'
          DataField = 'CXE_MOTIVO'
          DataSource = DtSrcEstornos
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 2
        end
        object st_usuarioEstorno: TStaticText
          Left = 149
          Top = 34
          Width = 112
          Height = 21
          AutoSize = False
          BorderStyle = sbsSingle
          Enabled = False
          TabOrder = 3
        end
        object btn_confirmaEstorno: TBitBtn
          Left = 8
          Top = 61
          Width = 129
          Height = 25
          Hint = 'Confirma estorno'
          Caption = 'Confirmar Estorno'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 4
          OnClick = btn_confirmaEstornoClick
          Glyph.Data = {
            DE010000424DDE01000000000000760000002800000024000000120000000100
            0400000000006801000000000000000000001000000000000000000000000000
            80000080000000808000800000008000800080800000C0C0C000808080000000
            FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
            3333333333333333333333330000333333333333333333333333F33333333333
            00003333344333333333333333388F3333333333000033334224333333333333
            338338F3333333330000333422224333333333333833338F3333333300003342
            222224333333333383333338F3333333000034222A22224333333338F338F333
            8F33333300003222A3A2224333333338F3838F338F33333300003A2A333A2224
            33333338F83338F338F33333000033A33333A222433333338333338F338F3333
            0000333333333A222433333333333338F338F33300003333333333A222433333
            333333338F338F33000033333333333A222433333333333338F338F300003333
            33333333A222433333333333338F338F00003333333333333A22433333333333
            3338F38F000033333333333333A223333333333333338F830000333333333333
            333A333333333333333338330000333333333333333333333333333333333333
            0000}
          NumGlyphs = 2
        end
        object btn_cancelarestorno: TBitBtn
          Left = 137
          Top = 61
          Width = 129
          Height = 25
          Hint = 'Cancela estorno'
          Caption = 'Cancelar'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 5
          OnClick = btn_cancelarestornoClick
          Glyph.Data = {
            DE010000424DDE01000000000000760000002800000024000000120000000100
            0400000000006801000000000000000000001000000000000000000000000000
            80000080000000808000800000008000800080800000C0C0C000808080000000
            FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
            333333333333333333333333000033338833333333333333333F333333333333
            0000333911833333983333333388F333333F3333000033391118333911833333
            38F38F333F88F33300003339111183911118333338F338F3F8338F3300003333
            911118111118333338F3338F833338F3000033333911111111833333338F3338
            3333F8330000333333911111183333333338F333333F83330000333333311111
            8333333333338F3333383333000033333339111183333333333338F333833333
            00003333339111118333333333333833338F3333000033333911181118333333
            33338333338F333300003333911183911183333333383338F338F33300003333
            9118333911183333338F33838F338F33000033333913333391113333338FF833
            38F338F300003333333333333919333333388333338FFF830000333333333333
            3333333333333333333888330000333333333333333333333333333333333333
            0000}
          NumGlyphs = 2
        end
      end
      object GB_DadosdoLancamento: TGroupBox
        Left = 4
        Top = 4
        Width = 612
        Height = 296
        Caption = 'Dados do Lan'#231'amento'
        TabOrder = 0
        object Label1: TLabel
          Left = 136
          Top = 87
          Width = 23
          Height = 13
          Caption = 'Data'
        end
        object Label10: TLabel
          Left = 8
          Top = 12
          Width = 41
          Height = 13
          Caption = 'Empresa'
        end
        object Label11: TLabel
          Left = 8
          Top = 48
          Width = 26
          Height = 13
          Caption = 'Caixa'
        end
        object Label2: TLabel
          Left = 256
          Top = 87
          Width = 24
          Height = 13
          Caption = 'Valor'
        end
        object Label3: TLabel
          Left = 8
          Top = 87
          Width = 55
          Height = 13
          Caption = 'Documento'
        end
        object Label4: TLabel
          Left = 8
          Top = 211
          Width = 58
          Height = 13
          Caption = 'Observa'#231#227'o'
        end
        object Label5: TLabel
          Left = 8
          Top = 172
          Width = 101
          Height = 13
          Caption = 'Forma de Pagamento'
        end
        object Label7: TLabel
          Left = 8
          Top = 130
          Width = 28
          Height = 13
          Caption = 'Conta'
        end
        object Label8: TLabel
          Left = 288
          Top = 130
          Width = 46
          Height = 13
          Caption = 'Subconta'
        end
        object Label15: TLabel
          Left = 415
          Top = 13
          Width = 56
          Height = 13
          Caption = 'Idf.Lancam.'
          FocusControl = DBEdit1
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentFont = False
        end
        object Label16: TLabel
          Left = 492
          Top = 13
          Width = 51
          Height = 13
          Caption = 'Data/Hora'
          FocusControl = DBEdit2
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentFont = False
        end
        object Label17: TLabel
          Left = 353
          Top = 172
          Width = 36
          Height = 13
          Caption = 'Usu'#225'rio'
          FocusControl = DBEdit3
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentFont = False
        end
        object edt_valor: TDBEdit
          Left = 256
          Top = 100
          Width = 110
          Height = 21
          Hint = 'Valor do lan'#231'amento'
          DataField = 'CXL_VALOR'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 6
        end
        object edt_subconta: TDBEdit
          Left = 288
          Top = 143
          Width = 65
          Height = 21
          Hint = 'C'#243'digo da subconta'
          DataField = 'CXL_SUBCODIGO'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 11
          OnExit = edt_subcontaExit
        end
        object edt_forma: TDBEdit
          Left = 8
          Top = 186
          Width = 65
          Height = 21
          Hint = 'C'#243'digo da forma de pagamento'
          DataField = 'CXL_FORMAPGTO'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 14
          OnExit = edt_formaExit
        end
        object edt_documento: TDBEdit
          Left = 8
          Top = 100
          Width = 121
          Height = 21
          Hint = 'N'#250'mero do documento'
          DataField = 'CXL_DOCUMENTO'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 4
        end
        object edt_data: TDBEdit
          Left = 136
          Top = 100
          Width = 113
          Height = 21
          Hint = 'Data de lan'#231'amento'
          DataField = 'CXL_DATA'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 5
        end
        object edt_conta: TDBEdit
          Left = 8
          Top = 143
          Width = 57
          Height = 21
          Hint = 'C'#243'digo da conta'
          DataField = 'CXL_SUBIDFCONTA'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 8
          OnExit = edt_contaExit
        end
        object memo_obs: TDBMemo
          Left = 8
          Top = 227
          Width = 594
          Height = 61
          Hint = 'Observa'#231#245'es '
          DataField = 'CXL_OBSERVACOES'
          DataSource = DtSrc
          ParentShowHint = False
          ShowHint = True
          TabOrder = 18
        end
        object rdg_tipo: TDBRadioGroup
          Left = 376
          Top = 92
          Width = 225
          Height = 41
          Hint = 'Tipo de Lan'#231'amento'
          Caption = 'Tipo de Lan'#231'amento'
          Columns = 3
          DataField = 'CXL_TIPO'
          DataSource = DtSrc
          Items.Strings = (
            'Entrada'
            'Sa'#237'da'
            'Informativo')
          TabOrder = 7
          Values.Strings = (
            'E'
            'S'
            'I')
        end
        object st_caixa: TStaticText
          Left = 89
          Top = 62
          Width = 320
          Height = 20
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 3
        end
        object st_subconta: TStaticText
          Left = 378
          Top = 144
          Width = 225
          Height = 20
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 13
        end
        object st_forma: TStaticText
          Left = 98
          Top = 188
          Width = 247
          Height = 20
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 16
        end
        object st_empresa: TStaticText
          Left = 89
          Top = 26
          Width = 320
          Height = 20
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 1
        end
        object st_conta: TStaticText
          Left = 90
          Top = 144
          Width = 191
          Height = 20
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 10
        end
        object st_UsuarioCorrente: TStaticText
          Left = 402
          Top = 186
          Width = 199
          Height = 21
          AutoSize = False
          BorderStyle = sbsSingle
          TabOrder = 17
        end
        object Btn_Empresa: TBitBtn
          Left = 63
          Top = 25
          Width = 25
          Height = 21
          Hint = 'Pesquisa empresas'
          Caption = '...'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 0
          TabStop = False
          OnClick = Btn_EmpresaClick
        end
        object Btn_Caixa: TBitBtn
          Left = 63
          Top = 61
          Width = 25
          Height = 21
          Hint = 'Pesquisa caixas'
          Caption = '...'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 2
          TabStop = False
          OnClick = Btn_CaixaClick
        end
        object Btn_Conta: TBitBtn
          Left = 65
          Top = 143
          Width = 25
          Height = 21
          Hint = 'Pesquisa contas'
          Caption = '...'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 9
          TabStop = False
          OnClick = Btn_ContaClick
        end
        object Btn_Subconta: TBitBtn
          Left = 353
          Top = 143
          Width = 25
          Height = 21
          Hint = 'Pesquisa subcontas'
          Caption = '...'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 12
          TabStop = False
          OnClick = Btn_SubcontaClick
        end
        object Btn_FormaPagto: TBitBtn
          Left = 73
          Top = 187
          Width = 25
          Height = 21
          Hint = 'Pesquisa formas de pagamento'
          Caption = '...'
          Enabled = False
          ParentShowHint = False
          ShowHint = True
          TabOrder = 15
          TabStop = False
          OnClick = Btn_FormaPagtoClick
        end
        object DBEdit1: TDBEdit
          Left = 416
          Top = 27
          Width = 72
          Height = 20
          TabStop = False
          AutoSize = False
          Color = clBtnFace
          Ctl3D = False
          DataField = 'CXL_LANCAMENTOIDF'
          DataSource = DtSrc
          Enabled = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentCtl3D = False
          ParentFont = False
          ReadOnly = True
          TabOrder = 19
        end
        object DBEdit2: TDBEdit
          Left = 492
          Top = 27
          Width = 107
          Height = 21
          TabStop = False
          AutoSize = False
          Color = clBtnFace
          Ctl3D = False
          DataField = 'CXL_DATALANCAMENTO'
          DataSource = DtSrc
          Enabled = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentCtl3D = False
          ParentFont = False
          ReadOnly = True
          TabOrder = 20
        end
        object DBEdit3: TDBEdit
          Left = 353
          Top = 186
          Width = 48
          Height = 21
          TabStop = False
          AutoSize = False
          Color = clBtnFace
          Ctl3D = False
          DataField = 'CXL_USUARIO'
          DataSource = DtSrc
          Enabled = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          ParentCtl3D = False
          ParentFont = False
          ReadOnly = True
          TabOrder = 21
        end
        object st_estornado: TStaticText
          Left = 493
          Top = 65
          Width = 107
          Height = 18
          Alignment = taCenter
          AutoSize = False
          BevelKind = bkFlat
          BorderStyle = sbsSingle
          Caption = 'ESTORNADO'
          Color = clBtnFace
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = [fsBold]
          ParentColor = False
          ParentFont = False
          TabOrder = 22
          Transparent = False
          Visible = False
        end
        object edt_empresa: TEdit
          Left = 8
          Top = 26
          Width = 53
          Height = 21
          TabOrder = 23
          OnExit = edt_empresaExit
        end
        object edt_caixa: TEdit
          Left = 8
          Top = 62
          Width = 54
          Height = 21
          TabOrder = 24
          OnExit = edt_caixaExit
        end
        object DBCheckBox1: TDBCheckBox
          Left = 416
          Top = 64
          Width = 73
          Height = 17
          Caption = 'Autom'#225'tico'
          DataField = 'CXL_AUTOMATICO'
          DataSource = DtSrc
          ReadOnly = True
          TabOrder = 25
          ValueChecked = 'S'
          ValueUnchecked = 'N'
        end
      end
    end
  end
  inherited DtSrc: TDataSource
    AutoEdit = False
    DataSet = CDS_CAIXALANCAMENTOS
    Top = 0
  end
  object DtSrcEstornos: TDataSource
    AutoEdit = False
    DataSet = CDS_ESTORNO
    Left = 96
  end
  object CDS_CAIXALANCAMENTOS: TClientDataSet
    Aggregates = <>
    Params = <
      item
        DataType = ftUnknown
        Name = 'CXL_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
    ProviderName = 'DSP_CAIXALANCAMENTOS'
    AfterClose = SQLC_CAIXALANCAMENTOSAfterClose
    AfterScroll = SQLC_CAIXALANCAMENTOSAfterScroll
    Left = 229
    Top = 205
    object CDS_CAIXALANCAMENTOSCXL_LANCAMENTOIDF: TIntegerField
      FieldName = 'CXL_LANCAMENTOIDF'
      Required = True
    end
    object CDS_CAIXALANCAMENTOSCXL_CAIXAIDF: TIntegerField
      FieldName = 'CXL_CAIXAIDF'
      Required = True
    end
    object CDS_CAIXALANCAMENTOSCXL_DOCUMENTO: TIntegerField
      FieldName = 'CXL_DOCUMENTO'
    end
    object CDS_CAIXALANCAMENTOSCXL_DATA: TDateField
      FieldName = 'CXL_DATA'
    end
    object CDS_CAIXALANCAMENTOSCXL_VALOR: TFloatField
      FieldName = 'CXL_VALOR'
      Required = True
    end
    object CDS_CAIXALANCAMENTOSCXL_TIPO: TStringField
      FieldName = 'CXL_TIPO'
      Size = 1
    end
    object CDS_CAIXALANCAMENTOSCXL_FORMAPGTO: TSmallintField
      FieldName = 'CXL_FORMAPGTO'
      Required = True
    end
    object CDS_CAIXALANCAMENTOSCXL_OBSERVACOES: TMemoField
      FieldName = 'CXL_OBSERVACOES'
      BlobType = ftMemo
    end
    object CDS_CAIXALANCAMENTOSCXL_ESTORNADO: TStringField
      FieldName = 'CXL_ESTORNADO'
      Required = True
      Size = 1
    end
    object CDS_CAIXALANCAMENTOSCXL_SUBIDFCONTA: TStringField
      FieldName = 'CXL_SUBIDFCONTA'
      Required = True
      Size = 3
    end
    object CDS_CAIXALANCAMENTOSCXL_SUBCODIGO: TStringField
      FieldName = 'CXL_SUBCODIGO'
      Required = True
      Size = 3
    end
    object CDS_CAIXALANCAMENTOSCXL_USUARIO: TStringField
      FieldName = 'CXL_USUARIO'
      Required = True
      Size = 3
    end
    object CDS_CAIXALANCAMENTOSCXL_DATALANCAMENTO: TDateTimeField
      FieldName = 'CXL_DATALANCAMENTO'
    end
    object CDS_CAIXALANCAMENTOSCXL_AUTOMATICO: TStringField
      FieldName = 'CXL_AUTOMATICO'
      Required = True
      Size = 1
    end
  end
  object CDS_ESTORNO: TClientDataSet
    Aggregates = <>
    Params = <
      item
        DataType = ftUnknown
        Name = 'CXE_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
    ProviderName = 'DSP_ESTORNO'
    AfterScroll = SQLC_ESTORNOAfterScroll
    Left = 493
    Top = 205
  end
  object DSP_CAIXALANCAMENTOS: TDataSetProvider
    DataSet = SQL_CAIXALANCAMENTOS
    Left = 192
    Top = 256
  end
  object DSP_ESTORNO: TDataSetProvider
    DataSet = SQL_ESTORNO
    Left = 485
    Top = 275
  end
  object SQL_CAIXALANCAMENTOS: TZQuery
    Connection = DtmGeral.ZConexaoBanco
    UpdateObject = UpdateCaixaLancamentos
    SQL.Strings = (
      
        'SELECT * FROM CAIXAS_LANCAMENTOS WHERE CXL_LANCAMENTOIDF = :CXL_' +
        'LANCAMENTOIDF')
    Params = <
      item
        DataType = ftUnknown
        Name = 'CXL_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
    Left = 85
    Top = 275
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'CXL_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
  end
  object SQL_ESTORNO: TZQuery
    Connection = DtmGeral.ZConexaoBanco
    UpdateObject = UpdateCaixaEstorno
    SQL.Strings = (
      
        'select * from CAIXAS_ESTORNOS WHERE  CXE_LANCAMENTOIDF = :CXE_LA' +
        'NCAMENTOIDF')
    Params = <
      item
        DataType = ftUnknown
        Name = 'CXE_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
    Left = 365
    Top = 275
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'CXE_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
  end
  object UpdateCaixaEstorno: TZUpdateSQL
    DeleteSQL.Strings = (
      'DELETE FROM CAIXAS_ESTORNOS'
      'WHERE'
      '  CAIXAS_ESTORNOS.CXE_LANCAMENTOIDF = '
      ':OLD_CXE_LANCAMENTOIDF')
    InsertSQL.Strings = (
      'INSERT INTO CAIXAS_ESTORNOS'
      '  (CXE_LANCAMENTOIDF, CXE_DATA, CXE_USUARIO, CXE_MOTIVO)'
      'VALUES'
      '  (:CXE_LANCAMENTOIDF, :CXE_DATA, :CXE_USUARIO, '
      ':CXE_MOTIVO)')
    ModifySQL.Strings = (
      'UPDATE CAIXAS_ESTORNOS SET'
      '  CXE_LANCAMENTOIDF = :CXE_LANCAMENTOIDF,'
      '  CXE_DATA = :CXE_DATA,'
      '  CXE_USUARIO = :CXE_USUARIO,'
      '  CXE_MOTIVO = :CXE_MOTIVO'
      'WHERE'
      '  CAIXAS_ESTORNOS.CXE_LANCAMENTOIDF = '
      ':OLD_CXE_LANCAMENTOIDF')
    UseSequenceFieldForRefreshSQL = False
    Left = 429
    Top = 363
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'CXE_LANCAMENTOIDF'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXE_DATA'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXE_USUARIO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXE_MOTIVO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'OLD_CXE_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
  end
  object UpdateCaixaLancamentos: TZUpdateSQL
    DeleteSQL.Strings = (
      'DELETE FROM CAIXAS_LANCAMENTOS'
      'WHERE'
      '  CAIXAS_LANCAMENTOS.CXL_LANCAMENTOIDF = '
      ':OLD_CXL_LANCAMENTOIDF')
    InsertSQL.Strings = (
      'INSERT INTO CAIXAS_LANCAMENTOS'
      '  (CXL_LANCAMENTOIDF, CXL_CAIXAIDF, CXL_DOCUMENTO, '
      'CXL_DATA, CXL_VALOR, '
      '   CXL_TIPO, CXL_FORMAPGTO, CXL_OBSERVACOES, '
      'CXL_ESTORNADO, CXL_SUBIDFCONTA, '
      '   CXL_SUBCODIGO, CXL_USUARIO, CXL_DATALANCAMENTO, '
      'CXL_AUTOMATICO)'
      'VALUES'
      '  (:CXL_LANCAMENTOIDF, :CXL_CAIXAIDF, :CXL_DOCUMENTO, '
      ':CXL_DATA, :CXL_VALOR, '
      '   :CXL_TIPO, :CXL_FORMAPGTO, :CXL_OBSERVACOES, '
      ':CXL_ESTORNADO, :CXL_SUBIDFCONTA, '
      '   :CXL_SUBCODIGO, :CXL_USUARIO, :CXL_DATALANCAMENTO, '
      ':CXL_AUTOMATICO)')
    ModifySQL.Strings = (
      'UPDATE CAIXAS_LANCAMENTOS SET'
      '  CXL_LANCAMENTOIDF = :CXL_LANCAMENTOIDF,'
      '  CXL_CAIXAIDF = :CXL_CAIXAIDF,'
      '  CXL_DOCUMENTO = :CXL_DOCUMENTO,'
      '  CXL_DATA = :CXL_DATA,'
      '  CXL_VALOR = :CXL_VALOR,'
      '  CXL_TIPO = :CXL_TIPO,'
      '  CXL_FORMAPGTO = :CXL_FORMAPGTO,'
      '  CXL_OBSERVACOES = :CXL_OBSERVACOES,'
      '  CXL_ESTORNADO = :CXL_ESTORNADO,'
      '  CXL_SUBIDFCONTA = :CXL_SUBIDFCONTA,'
      '  CXL_SUBCODIGO = :CXL_SUBCODIGO,'
      '  CXL_USUARIO = :CXL_USUARIO,'
      '  CXL_DATALANCAMENTO = :CXL_DATALANCAMENTO,'
      '  CXL_AUTOMATICO = :CXL_AUTOMATICO'
      'WHERE'
      '  CAIXAS_LANCAMENTOS.CXL_LANCAMENTOIDF = '
      ':OLD_CXL_LANCAMENTOIDF')
    UseSequenceFieldForRefreshSQL = False
    Left = 541
    Top = 339
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'CXL_LANCAMENTOIDF'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_CAIXAIDF'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_DOCUMENTO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_DATA'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_VALOR'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_TIPO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_FORMAPGTO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_OBSERVACOES'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_ESTORNADO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_SUBIDFCONTA'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_SUBCODIGO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_USUARIO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_DATALANCAMENTO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'CXL_AUTOMATICO'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'OLD_CXL_LANCAMENTOIDF'
        ParamType = ptUnknown
      end>
  end
end
